package com.simtop.dao;

import com.simtop.pojo.experiment.ExperimentScore;
import com.simtop.pojo.experiment.ExperimentScoreExport;
import com.simtop.pojo.experiment.ReportScore;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;

/**
 * @author lvyongwei
 */
@Mapper
public interface ExperimentScoreDao {

    /**
     * 添加实验成绩
     * @param experimentScore
     * @return
     */
    public boolean insertExperimentScore(ExperimentScore experimentScore);

    /**
     * 获取实验数量
     * @return
     */
    public Integer getScoreCount();

    /**
     * 获取实验总时长
     * @return
     */
    public Long getScoreTime();

    /**
     * 获取成绩分布
     * @return
     */
    public ReportScore getScoreDistribution();

    /**
     * 实验报告查询
     * @param experimentScore
     * @return
     */
    public List<ExperimentScore> getAllExperimentScore(ExperimentScore experimentScore);

    /**
     * 实验报告导出
     * @param beginTime
     * @param endTime
     * @param school
     * @return
     */
    public List<ExperimentScoreExport> experimentExport(@Param("beginDate")String beginTime, @Param("endDate") String endTime, @Param("school")String school);
}
